/**
 * @description  : sql 示例
 * @descriptionDetail : sql 示例
 * @copyright    : 浙江烟草
 * @author       : mc
 * @create       : 2022-10-04 16:48:19
 */
const sql = {
  // 创建示例表
  createDemoSQL: 'CREATE TABLE IF NOT EXISTS DEMO (' +
        'id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,' +
        'userCode VARCHAR,' +
        'password VARCHAR,' +
        'isSavePass VARCHAR,' +
        'userName VARCHAR,' +
        'account VARCHAR)',
  // 向示例表插入数据
  insertDemoSQL: "INSERT INTO DEMO(userCode, password,isSavePass,userName,account) " +
        "VALUES( ?, ?, ?, ?, ?)",
  queryDemoAllSQL: "select * from DEMO",
  queryDemowhereUserCodeSQL: "select * from DEMO where userCode=?",
  updataDemoPasswordSQL: "update DEMO set password=? where id=?",

}

export default {
  sql,
}
